CREATE OR REPLACE PACKAGE PKG_BRN_MANAGER AS
/*****************************************************************************
* Name : PKG_BRN_MANAGER
* Type : Package Specification 
* Description : Package is used to get the next available BRN. 
*               Returns BRN and expiry timestamp.
*
*
* Amendment History :
*
* Version  Date         Changed By     Reason (e.g. Initial, Change Ref)
******************************************************************************
* 0.1      28/08/2013    Rajeeva Tiwari      Initial
*****************************************************************************/

  gc_package_name     VARCHAR2(30) := $$PLSQL_UNIT; 
  
  PROCEDURE get_brn( p_ap_txn_id IN t_basket_reference.ap_txn_id%TYPE
                   , p_reconciliation_cycle_id IN t_basket_reference.reconciliation_cycle_id%TYPE
                   , p_reconciliation_date IN t_basket_reference.reconciliation_date%TYPE
                   , p_brn  OUT t_basket_reference_master.basket_reference_number%TYPE
                   , p_exp_tmstmp  OUT t_basket_reference.expiry_tmstmp%TYPE); 
    
  END PKG_BRN_MANAGER;
/
